Workflows

Workflows enable you to run tasks both sequentially and in parallel. You can either schedule workflows as described in Scheduling tasks or run them manually using the Run toolbar button.

You can create your own workflow and/or use the built-in workflow. The built-in workflow enables you to run all of your data warehouse and data mart tasks as a single, end-to-end process. In a project with a single data mart, all tasks run sequentially in the default workflow, starting with the data warehouse tasks and ending with the data mart task. However, in projects with multiple data marts, the data mart tasks run in parallel, following the completion of the data warehouse tasks.

When you create your own workflow, you decide which tasks to include in the workflow and the order in which they will be run.

In this topic:

• Adding and designing workflows
• Validating workflows
• Managing workflows
• Running and monitoring workflows